<?xml version="1.0" encoding="UTF-8"?>
<!-- 
	 公共SQLMAP配置
-->
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "./sql-map-2.dtd">
 
<sqlMap > 
	<!-- 主键sql -->
	<select id="getSequencesValue" parameterClass="java.lang.String" resultClass="java.lang.String" remapResults="true">
		select seqformat(@in_seq_name:='$seqName$')
	</select>
	<!-- 动态sql -->
	<select id="dynamicSql" parameterClass="java.lang.String" resultClass="java.util.HashMap" remapResults="true" >
		$dynamicSql$
	</select>
	<!-- 数据字典sql -->
	<select id="parameterValue" parameterClass="java.util.HashMap" resultClass="java.util.HashMap" remapResults="true"  >
     	select b.id as id,b.dictvalue as name from (select * from t_dictionary where sysdictid='$pid$') a left join (select * from t_dictionaryd where state=1)  b on a.id=b.pid			
	</select>
</sqlMap>